package com.oct.website.mapper;

import java.math.BigDecimal;
import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.Select;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.oct.website.entity.ThiData;

public interface ThiDataMapper extends BaseMapper<ThiData>{
	
	
	@Select("select thi_index from thi_data where scenic_name1=#{scenicName} and time1=(select max(time1) from thi_data)")
	BigDecimal queryThiNewValue(String scenicName);
	
	@Select("select time1, thi_index from thi_data where scenic_name1=#{scenicName} order by time1 desc limit 12")
	List<Map> queryThiSta(String scenicName);
}
